Dataphin数据集成中SAP HANA可以选到表, 但是管道任务中报错invalid table name: Could not find table/view CE9PB00_H in schema SLT

问题描述

Dataphin数据集成中SAP HANA可以选到表，但是管道任务中报错“invalid table name: Could not find table/view CE9PB00_H in schema SLT_USER”。

2022-09-23 09:42:20.231 [job-1042479] ERROR DlinkTransPreview - Exception when job run
com.alibaba.dt.pipeline.plugin.center.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.].  - 执行的SQL为: select * from CE9PB00_H where 1=2 具体错误信息为：com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259] (at 14): invalid table name:  Could not find table/view CE9PB00_H in schema SLT_USER: line 1 col 15 (at pos 14)
  at com.alibaba.dt.pipeline.plugin.center.exception.DataXException.asDataXException(DataXException.java:40) ~[plugin.center.base-v2.9.5.3-2.RELEASE.jar:na]
  at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumnsByConnInternal(DBUtil.java:693) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumnsByConn(DBUtil.java:665) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumns(DBUtil.java:661) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:249) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.simplifyConf(OriginalConfPretreatmentUtil.java:71) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.doPretreatment(OriginalConfPretreatmentUtil.java:43) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Job.init(CommonRdbmsReader.java:84) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.datax.plugin.reader.saphanareader.SAPHanaReader$Job.init(SAPHanaReader.java:55) ~[saphanareader-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.trans.DlinkTransRunner.initJobReader(DlinkTransRunner.java:59) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.trans.DlinkTransPreview.doInit(DlinkTransPreview.java:285) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.trans.DlinkTransPreview.start(DlinkTransPreview.java:230) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.Engine.runTransPreview(Engine.java:101) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.Engine.entry(Engine.java:174) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
  at com.alibaba.dt.dlink.core.Engine.main(Engine.java:246) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
2022-09-23 09:42:20.242 [job-1042479] ERROR Engine -

问题原因

数据源URL中没有加入schema信息。目前我们的设计，需要配置一个兜底的schema。

解决方案

SAP HANA数据源中URL加入schema信息。

具体格式：jdbc:sap://host:Port/?databaseName=&currentSchema=

适用于

Dataphin